{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Students","Groups"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Students","index":0,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["ID","Group","Category 1","Category 2","Category 3","Names"]
[1,"Parallelogram",null,null,null,"Boysname1"]
[2,"Kite",null,null,null,"Boysname2"]
[3,"Kite",1,null,null,"Girslname1"]
[4,"Rectangle",1,null,null,"Girslname2"]
[5,"Kite",1,null,null,"Girslname3"]
[6,"Rhombus",null,null,null,"Boysname3"]
[7,"Rhombus",1,null,null,"Girslname4",null,null,null,null,"Instructions:"]
[8,"Kite",null,null,null,"Boysname4",null,null,null,null,"On the worksheet Groups, enter names for your groups and ensure that the sum of the group sizes is equal to the total number of students"]
[9,"Rhombus",1,null,null,"Girslname5",null,null,null,null,"Enter your students names in column F, and fill out their id numbers in column A"]
[10,"Square",1,null,null,"Girslname6",null,null,null,null,"Enter 1 in column C for each female student"]
[11,"Parallelogram",null,null,null,"Boysname5",null,null,null,null,"Click generate groups and students will be randomly assigned to groups in such a way that no women are isolated"]
[12,"Parallelogram",null,null,null,"Boysname6",null,null,null,null,"The groups are assigned in column B"]
[13,"Rectangle",null,null,null,"Boysname7",null,null,null,null,"You can add another category or two of students who should not be isolated in groups"]
[14,"Rectangle",null,null,null,"Boysname8",null,null,null,null,"If you have a category with only two or three students, expect this to take a LONG time to run, and for the students to ask why they are always paired together."]
[15,"Rectangle",1,null,null,"Girslname7"]
[16,"Square",null,null,null,"Boysname9"]
[17,"Parallelogram",null,null,null,"Boysname10"]
[18,"Square",1,null,null,"Girslname8"]
[]
[]
[]
[]
[]
[]
[]
["count of","all","Category 1","Category 2","Category 3"]
["Rhombus",{"$f":"COUNTIF($B$2:$B$19,$A28)","v":3},{"$f":"COUNTIFS($B$2:$B$19,$A28,C$2:C$19,1)","v":2},0,0]
["Parallelogram",{"$f":"COUNTIF($B$2:$B$19,$A29)","v":4},0,0,0]
["Square",{"$f":"COUNTIF($B$2:$B$19,$A30)","v":3},2,0,0]
["Kite",{"$f":"COUNTIF($B$2:$B$19,$A31)","v":4},2,0,0]
["Rectangle",{"$f":"COUNTIF($B$2:$B$19,$A32)","v":4},2,0,0]
[]
[]
[]
[null,{"$f":"SUM(B28:B32)","v":18},{"$f":"SUM(C28:C32)","v":8},{"$f":"SUM(D28:D32)","v":0},{"$f":"SUM(E28:E32)","v":0}]
[]
[]
["count of","all","Category 1","Category 2","Category 3"]
["Red",{"$f":"COUNTIF($B$2:$B$19,$A40)","v":0},{"$f":"COUNTIFS($B$2:$B$19,$A40,C$2:C$19,1)","v":0},0,0]
["Green",{"$f":"COUNTIF($B$2:$B$19,$A41)","v":0},0,0,0]
["Purple",{"$f":"COUNTIF($B$2:$B$19,$A42)","v":0},0,0,0]
["Orange",{"$f":"COUNTIF($B$2:$B$19,$A43)","v":0},0,0,0]
["Cyan",{"$f":"COUNTIF($B$2:$B$19,$A44)","v":0},0,0,0]
[]
[]
[]
[null,{"$f":"SUM(B40:B44)","v":0},{"$f":"SUM(C40:C44)","v":0},{"$f":"SUM(D40:D44)","v":0},{"$f":"SUM(E40:E44)","v":0}]

{"sheet":"Groups","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ID","Name","Number of members"]
[1,"Square",3]
[2,"Rectangle",4]
[3,"Rhombus",3]
[4,"Kite",4]
[5,"Parallelogram",4]